﻿CREATE TABLE [dbo].[Category]
(
	[Id] uniqueidentifier NOT NULL,
	[Name] nvarchar(100)  NOT NULL,
	[Title] nvarchar (100)  NULL,
	[ShortDescription] nvarchar(1000)  NULL,
	[LongDescription] nvarchar (max)  NULL,
	[Keywords] nvarchar (1000)  NULL,
	[ParentCategoryId] uniqueidentifier NULL,
	[ImageFullsize] nvarchar (200)  NULL,
	[ImageThumbnail] nvarchar (200)  NULL,
	[SortOrder] int NOT NULL,
	[Visible] [bit] NOT NULL
)


